package com.lzctzk.serviceaddress.dao;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Title:
 * Description:
 * Company:
 *
 * @user GuiYue
 * @time 15:09
 * @project_name service-address
 * @package_name com.lzctzk.serviceaddress.dao
 **/


public interface MyHouseMapper extends HouseMapper
{
    @Select("SELECT DISTINCT STREET FROM HOUSE WHERE A_AREA = #{aArea}")
    List<String> listStreet(@Param("aArea") String aArea);

    @Select("SELECT DISTINCT COMMUNITY FROM HOUSE WHERE STREET = #{street}")
    List<String> listCommunity (@Param("street") String street);
}
